<%@ page import="fachada.*,java.util.ArrayList,java.sql.*, conexao.*;" contentType="text/html; charset=UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US" xml:lang="en">
<head>
    <!--
    Created by Artisteer v2.5.0.29918
    Base template (without user's data) checked by http://validator.w3.org : "This page is valid XHTML 1.0 Transitional"
    -->
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
    <title>Lista de Veículos </title>

    <link rel="stylesheet" href="layout/style.css" type="text/css" media="screen" />
    <!--[if IE 6]><link rel="stylesheet" href="style.ie6.css" type="text/css" media="screen" /><![endif]-->
    <!--[if IE 7]><link rel="stylesheet" href="style.ie7.css" type="text/css" media="screen" /><![endif]-->

    <script type="text/javascript" src="script.js"></script>
</head>
<body>
    <div id="art-page-background-gradient"></div>
    <div id="art-page-background-glare">
        <div id="art-page-background-glare-image"></div>
    </div>
    <div id="art-main">
        <div class="art-sheet">
            <div class="art-sheet-tl"></div>
            <div class="art-sheet-tr"></div>
            <div class="art-sheet-bl"></div>
            <div class="art-sheet-br"></div>
            <div class="art-sheet-tc"></div>
            <div class="art-sheet-bc"></div>
            <div class="art-sheet-cl"></div>
            <div class="art-sheet-cr"></div>
            <div class="art-sheet-cc"></div>
            <div class="art-sheet-body">
                <div class="art-nav">
                	<ul class="art-menu">
                		
                	</ul>
                </div>
                <div class="art-header">
                    <div class="art-header-jpeg"></div>
                    <script type="text/javascript" src="swfobject.js"></script>
                    <div id="art-flash-area">
                    <div id="art-flash-container">
                    <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="900" height="225" id="art-flash-object">
                        <param name="movie" value="images/flash.swf" />
                        <param name="quality" value="high" />
                    	<param name="scale" value="exactfit" />
                    	<param name="wmode" value="transparent" />
                    	<param name="flashvars" value="color1=0xFFFFFF&amp;alpha1=.76&amp;framerate1=24&amp;loop=true" />
                        <param name="swfliveconnect" value="true" />
                        <!--[if !IE]>-->
                        <object type="application/x-shockwave-flash" data="layout/images/flash.swf" width="900" height="225">
                            <param name="quality" value="high" />
                    	    <param name="scale" value="exactfit" />
                    	    <param name="wmode" value="transparent" />
                    	    <param name="flashvars" value="color1=0xFFFFFF&amp;alpha1=.76&amp;framerate1=24&amp;loop=true" />
                            <param name="swfliveconnect" value="true" />
                        <!--<![endif]-->
                          	<div class="art-flash-alt"><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></div>
                        <!--[if !IE]>-->
                        </object>
                        <!--<![endif]-->
                    </object>
                    </div>
                    </div>
                    <script type="text/javascript">swfobject.switchOffAutoHideShow();swfobject.registerObject("art-flash-object", "9.0.0", "expressInstall.swf");</script>
                   
                </div>
                <div class="art-content-layout">
                    <div class="art-content-layout-row">
                        <div class="art-layout-cell art-content">
                            <div class="art-post">
                                <div class="art-post-tl"></div>
                                <div class="art-post-tr"></div>
                                <div class="art-post-bl"></div>
                                <div class="art-post-br"></div>
                                <div class="art-post-tc"></div>
                                <div class="art-post-bc"></div>
                                <div class="art-post-cl"></div>
                                <div class="art-post-cr"></div>
                                <div class="art-post-cc"></div>
                                <div class="art-post-body">
                            <div class="art-post-inner art-article">
          

<p align="center">
		<b> <font size="+3">Loc AutoWeb - Lista de Veículos</font> </b>
	</p>
	
			
			
		<%
			Connection conn = null;
			Statement stmt = null;
			ResultSet rset = null;
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","sa");
			stmt = conn.createStatement();
			rset = stmt.executeQuery("select v.placa, v.ano, v.foto, v.acessorio, deref(cor).descricao as cor, deref(modelo).descricao as mod from tb_veiculo v"); 

			while (rset.next()) {

		%>
		
<center>
	<div style="float:left; width:33%">
		<table>
			<tr><td align="left">
				<img src="displayfoto?placa=<%=rset.getObject("placa")%>" width="238" height="228">
			</td></tr>
			<tr><td align="left">
			   		  Ano: <%=rset.getObject("ano")%><br>
				Acessório: <%=rset.getObject("acessorio")%><br>
					  Cor: <%=rset.getObject("cor")%><br>
				   Modelo: <%=rset.getObject("mod")%>	
				<!-- <a href="TelaExibirAltVeiculo.jsp?placa=<%=rset.getObject("placa")%>">(FINALIZAR ANUNCIO)</a>
				<a href="TelaExibirExcVeiculo.jsp?placa=<%=rset.getObject("placa")%>">(EXC)</a> -->		
			</td></tr>
			</table>
	</div>
</center>
		
		<% } conn.close();%>
	
	             
                                            <div class="cleared"></div>
                            </div>
                            
                            		<div class="cleared"></div>
                            		<center><br><input type="button" onclick="history.back(-1)" value="Voltar"/></center>
                                </div>
                            </div>
                           
                        </div>
                    </div>
                </div>
                <div class="cleared"></div><div class="art-footer">
                    <div class="art-footer-t"></div>
                    <div class="art-footer-l"></div>
                    <div class="art-footer-b"></div>
                    <div class="art-footer-r"></div>
                    <div class="art-footer-body">
                         <a href="#" class="art-rss-tag-icon" title="RSS"></a>
                        <div class="art-footer-text">
                            <p>Copyright &copy; 2012 --- É proibida a reprodu&ccedil;&atilde;o total ou parcial do conte&uacute;do deste site para fins comerciais. 
 Tecnologia, Arte e Desenvolvimento: Anderson Elias, Alexsandro Marques, Marcello Pedrosa e Rosiberto Santos.</p>
                        </div>
                		<div class="cleared"></div>
                    </div>
                </div>
        		<div class="cleared"></div>
            </div>
        </div>
        <div class="cleared"></div>
        <p class="art-page-footer"><a href="http://www.facebook.com/locautoweb">Loc AutoWeb</a></p>
    </div>
    
</body>
</html>
	

